#!/bin/sh

echo "select * from persondata;" | mysql persondata -u root -p

echo "Enter pnr to delete"
read pnr

echo "delete from persondata where pnr='$pnr'" | mysql persondata -u root -p 
